package com.aierkeji.call.b2c.dao.jpa;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import com.aierkeji.call.b2c.dao.BaseJPADao;
import com.aierkeji.call.b2c.dao.jpa.custom.AkjCallClueStatisticsDaoCustom;
import com.aierkeji.call.b2c.entity.AkjCallClueStatistics;
import com.aierkeji.call.b2c.entity.AkjCallClueStatisticsVo;

public interface AkjCallClueStatisticsDao extends BaseJPADao<AkjCallClueStatistics, String>, AkjCallClueStatisticsDaoCustom{

	@Query("select t from AkjCallClueStatistics t where year = :year and month = :month and t.day = :day and callUserId = :callUserId ORDER BY createdAt DESC")
	List<AkjCallClueStatistics> findByYearAndMonthAndDayAndCallUserId(@Param("year")Long year, @Param("month")Long month, @Param("day")Long day,@Param("callUserId")Long callUserId);


//	List<AkjCallClueStatistics> findByYearAndMonthAndDayAndCreatedBy(@Param("yearh")Long yearh, @Param("month")Long month,
//																	@Param("day")Long day, @Param("createdBy")Long createdBy);

	
	

}
